Dataset statistics
| Number of variables | 11 |
|---|---|
| Number of observations | 337336 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 28.3 MiB |
| Average record size in memory | 88.0 B |
Variable types
| NUM | 11 |
|---|
Reproduction
| Analysis started | 2020-07-16 22:16:24.926881 |
|---|---|
| Analysis finished | 2020-07-16 22:17:40.512863 |
| Duration | 1 minute and 15.59 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
year
Real number (ℝ≥0)
| Distinct count | 29 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2001.977512035478 |
|---|---|
| Minimum | 1988 |
| Maximum | 2016 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1988 |
|---|---|
| 5-th percentile | 1989 |
| Q1 | 1995 |
| median | 2002 |
| Q3 | 2009 |
| 95-th percentile | 2015 |
| Maximum | 2016 |
| Range | 28 |
| Interquartile range (IQR) | 14 |
Descriptive statistics
| Standard deviation | 8.354764043 |
|---|---|
| Coefficient of variation (CV) | 0.00417325569 |
| Kurtosis | -1.201571662 |
| Mean | 2001.977512 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 0.001011198733 |
| Sum | 675339086 |
| Variance | 69.80208222 |
| Value | Count | Frequency (%) | |
| 2003 | 11653 | 3.5% | |
| 2006 | 11653 | 3.5% | |
| 1994 | 11653 | 3.5% | |
| 1997 | 11653 | 3.5% | |
| 1998 | 11653 | 3.5% | |
| 1999 | 11653 | 3.5% | |
| 2000 | 11653 | 3.5% | |
| 2004 | 11653 | 3.5% | |
| 2005 | 11653 | 3.5% | |
| 1991 | 11653 | 3.5% | |
| Other values (19) | 220806 | 65.5% |
| Value | Count | Frequency (%) | |
| 1988 | 11642 | 3.5% | |
| 1989 | 11651 | 3.5% | |
| 1990 | 11651 | 3.5% | |
| 1991 | 11653 | 3.5% | |
| 1992 | 11652 | 3.5% |
| Value | Count | Frequency (%) | |
| 2016 | 11364 | 3.4% | |
| 2015 | 11364 | 3.4% | |
| 2014 | 11653 | 3.5% | |
| 2013 | 11653 | 3.5% | |
| 2012 | 11651 | 3.5% |
zipcode
Real number (ℝ≥0)
| Distinct count | 11653 |
|---|---|
| Unique (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 45406.37917091564 |
|---|---|
| Minimum | 1001 |
| Maximum | 99901 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1001 |
|---|---|
| 5-th percentile | 6040 |
| Q1 | 20109 |
| median | 40118 |
| Q3 | 71909 |
| 95-th percentile | 95693 |
| Maximum | 99901 |
| Range | 98900 |
| Interquartile range (IQR) | 51800 |
Descriptive statistics
| Standard deviation | 29263.42758 |
|---|---|
| Coefficient of variation (CV) | 0.6444783335 |
| Kurtosis | -1.135355825 |
| Mean | 45406.37917 |
| Median Absolute Deviation (MAD) | 24359 |
| Skewness | 0.3063681193 |
| Sum | 1.531720632e+10 |
| Variance | 856348193.7 |
| Value | Count | Frequency (%) | |
| 28658 | 29 | < 0.1% | |
| 97401 | 29 | < 0.1% | |
| 31833 | 29 | < 0.1% | |
| 78704 | 29 | < 0.1% | |
| 2903 | 29 | < 0.1% | |
| 33606 | 29 | < 0.1% | |
| 21084 | 29 | < 0.1% | |
| 31321 | 29 | < 0.1% | |
| 80241 | 29 | < 0.1% | |
| 98662 | 29 | < 0.1% | |
| Other values (11643) | 337046 | 99.9% |
| Value | Count | Frequency (%) | |
| 1001 | 29 | < 0.1% | |
| 1002 | 29 | < 0.1% | |
| 1005 | 29 | < 0.1% | |
| 1007 | 29 | < 0.1% | |
| 1010 | 29 | < 0.1% |
| Value | Count | Frequency (%) | |
| 99901 | 29 | < 0.1% | |
| 99801 | 29 | < 0.1% | |
| 99709 | 29 | < 0.1% | |
| 99701 | 29 | < 0.1% | |
| 99577 | 29 | < 0.1% |
EQI_zip
Real number (ℝ≥0)
| Distinct count | 330219 |
|---|---|
| Unique (%) | 97.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.000522528831953512 |
|---|---|
| Minimum | 1.1998789e-05 |
| Maximum | 0.0641894 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1.1998789e-05 |
|---|---|
| 5-th percentile | 0.000115540135 |
| Q1 | 0.0002105545275 |
| median | 0.0003217026 |
| Q3 | 0.0005152216375 |
| 95-th percentile | 0.001376939875 |
| Maximum | 0.0641894 |
| Range | 0.06417740121 |
| Interquartile range (IQR) | 0.00030466711 |
Descriptive statistics
| Standard deviation | 0.0010000942 |
|---|---|
| Coefficient of variation (CV) | 1.913950272 |
| Kurtosis | 491.5615115 |
| Mean | 0.000522528832 |
| Median Absolute Deviation (MAD) | 0.000133222525 |
| Skewness | 15.92369211 |
| Sum | 176.2677861 |
| Variance | 1.000188409e-06 |
| Value | Count | Frequency (%) | |
| 0.0004910004 | 58 | < 0.1% | |
| 0.0011926616 | 47 | < 0.1% | |
| 0.00023086638 | 46 | < 0.1% | |
| 0.0003055213 | 44 | < 0.1% | |
| 0.0016380961 | 42 | < 0.1% | |
| 0.0006648359 | 41 | < 0.1% | |
| 0.00022039752 | 39 | < 0.1% | |
| 0.0006497198 | 36 | < 0.1% | |
| 0.00073148106 | 32 | < 0.1% | |
| 0.0001871098 | 31 | < 0.1% | |
| Other values (330209) | 336920 | 99.9% |
| Value | Count | Frequency (%) | |
| 1.1998789e-05 | 1 | < 0.1% | |
| 1.3727406e-05 | 1 | < 0.1% | |
| 1.4215268e-05 | 1 | < 0.1% | |
| 1.4599402e-05 | 1 | < 0.1% | |
| 1.4817676e-05 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0.0641894 | 1 | < 0.1% | |
| 0.057795137 | 1 | < 0.1% | |
| 0.05652261 | 1 | < 0.1% | |
| 0.055170864 | 1 | < 0.1% | |
| 0.05462911 | 1 | < 0.1% |
SFR_zip
Real number (ℝ≥0)
| Distinct count | 1537 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 84.82791045130078 |
|---|---|
| Minimum | 1.0 |
| Maximum | 6883.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 14 |
| median | 38 |
| Q3 | 99 |
| 95-th percentile | 318 |
| Maximum | 6883 |
| Range | 6882 |
| Interquartile range (IQR) | 85 |
Descriptive statistics
| Standard deviation | 137.5204495 |
|---|---|
| Coefficient of variation (CV) | 1.621169834 |
| Kurtosis | 81.07312521 |
| Mean | 84.82791045 |
| Median Absolute Deviation (MAD) | 29 |
| Skewness | 5.741122524 |
| Sum | 28615508 |
| Variance | 18911.87402 |
| Value | Count | Frequency (%) | |
| 5 | 7324 | 2.2% | |
| 6 | 7278 | 2.2% | |
| 7 | 7211 | 2.1% | |
| 8 | 7094 | 2.1% | |
| 4 | 6946 | 2.1% | |
| 9 | 6781 | 2.0% | |
| 10 | 6649 | 2.0% | |
| 3 | 6490 | 1.9% | |
| 11 | 6169 | 1.8% | |
| 12 | 5906 | 1.8% | |
| Other values (1527) | 269488 | 79.9% |
| Value | Count | Frequency (%) | |
| 1 | 3601 | 1.1% | |
| 2 | 5407 | 1.6% | |
| 3 | 6490 | 1.9% | |
| 4 | 6946 | 2.1% | |
| 5 | 7324 | 2.2% |
| Value | Count | Frequency (%) | |
| 6883 | 1 | < 0.1% | |
| 5858 | 1 | < 0.1% | |
| 4307 | 1 | < 0.1% | |
| 4201 | 1 | < 0.1% | |
| 4103 | 1 | < 0.1% |
RECPI_zip
Real number (ℝ≥0)
| Distinct count | 331709 |
|---|---|
| Unique (%) | 98.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.043653849650231946 |
|---|---|
| Minimum | 1.1998789e-05 |
| Maximum | 9.541773 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1.1998789e-05 |
|---|---|
| 5-th percentile | 0.000963155455 |
| Q1 | 0.00415424315 |
| median | 0.013124878 |
| Q3 | 0.03799319525 |
| 95-th percentile | 0.16244798 |
| Maximum | 9.541773 |
| Range | 9.541761001 |
| Interquartile range (IQR) | 0.0338389521 |
Descriptive statistics
| Standard deviation | 0.1377787814 |
|---|---|
| Coefficient of variation (CV) | 3.156165665 |
| Kurtosis | 617.5952807 |
| Mean | 0.04365384965 |
| Median Absolute Deviation (MAD) | 0.0108302418 |
| Skewness | 18.25116806 |
| Sum | 14726.01503 |
| Variance | 0.0189829926 |
| Value | Count | Frequency (%) | |
| 0.0004910004 | 42 | < 0.1% | |
| 0.0003055213 | 35 | < 0.1% | |
| 0.0011926616 | 35 | < 0.1% | |
| 0.00023086638 | 35 | < 0.1% | |
| 0.0016380961 | 32 | < 0.1% | |
| 0.0006648359 | 32 | < 0.1% | |
| 0.00022039752 | 31 | < 0.1% | |
| 0.0006497198 | 23 | < 0.1% | |
| 0.0005609932 | 23 | < 0.1% | |
| 0.0001871098 | 23 | < 0.1% | |
| Other values (331699) | 337025 | 99.9% |
| Value | Count | Frequency (%) | |
| 1.1998789e-05 | 1 | < 0.1% | |
| 1.3727406e-05 | 1 | < 0.1% | |
| 1.4817676e-05 | 1 | < 0.1% | |
| 1.5237238e-05 | 1 | < 0.1% | |
| 1.7317287e-05 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 9.541773 | 1 | < 0.1% | |
| 9.173729 | 1 | < 0.1% | |
| 8.419393 | 1 | < 0.1% | |
| 7.458536 | 1 | < 0.1% | |
| 7.4182096 | 1 | < 0.1% |
EQI_MSA
Real number (ℝ≥0)
| Distinct count | 22829 |
|---|---|
| Unique (%) | 6.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0005629322789344037 |
|---|---|
| Minimum | 2.37131e-05 |
| Maximum | 0.015639344 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 2.37131e-05 |
|---|---|
| 5-th percentile | 0.00014410826 |
| Q1 | 0.00025185168 |
| median | 0.00038444618 |
| Q3 | 0.00058807 |
| 95-th percentile | 0.0016214617 |
| Maximum | 0.015639344 |
| Range | 0.0156156309 |
| Interquartile range (IQR) | 0.00033621832 |
Descriptive statistics
| Standard deviation | 0.0006875578172 |
|---|---|
| Coefficient of variation (CV) | 1.221386378 |
| Kurtosis | 55.81173025 |
| Mean | 0.0005629322789 |
| Median Absolute Deviation (MAD) | 0.00015124948 |
| Skewness | 5.788314398 |
| Sum | 189.8973232 |
| Variance | 4.72735752e-07 |
| Value | Count | Frequency (%) | |
| 0.00047340643 | 863 | 0.3% | |
| 0.0002361842 | 863 | 0.3% | |
| 0.00045508775 | 863 | 0.3% | |
| 0.00044633303 | 863 | 0.3% | |
| 0.0002569714 | 863 | 0.3% | |
| 0.0003858068 | 863 | 0.3% | |
| 0.00037916107 | 863 | 0.3% | |
| 0.00046495508 | 863 | 0.3% | |
| 0.00021529387 | 863 | 0.3% | |
| 0.00041259924 | 863 | 0.3% | |
| Other values (22819) | 328706 | 97.4% |
| Value | Count | Frequency (%) | |
| 2.37131e-05 | 2 | < 0.1% | |
| 2.7167029e-05 | 1 | < 0.1% | |
| 2.9056831e-05 | 6 | < 0.1% | |
| 3.2550477e-05 | 1 | < 0.1% | |
| 3.9400034e-05 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0.015639344 | 13 | < 0.1% | |
| 0.012493365 | 1 | < 0.1% | |
| 0.0103107365 | 259 | 0.1% | |
| 0.0095638605 | 1 | < 0.1% | |
| 0.00804525 | 2 | < 0.1% |
SFR_MSA
Real number (ℝ≥0)
| Distinct count | 3540 |
|---|---|
| Unique (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9500.565492565276 |
|---|---|
| Minimum | 1.0 |
| Maximum | 153589.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 62 |
| Q1 | 366 |
| median | 1718 |
| Q3 | 9603 |
| 95-th percentile | 50318 |
| Maximum | 153589 |
| Range | 153588 |
| Interquartile range (IQR) | 9237 |
Descriptive statistics
| Standard deviation | 17572.36921 |
|---|---|
| Coefficient of variation (CV) | 1.849612976 |
| Kurtosis | 14.45310417 |
| Mean | 9500.565493 |
| Median Absolute Deviation (MAD) | 1607 |
| Skewness | 3.262329342 |
| Sum | 3204882761 |
| Variance | 308788159.7 |
| Value | Count | Frequency (%) | |
| 1 | 3061 | 0.9% | |
| 50318 | 1726 | 0.5% | |
| 58630 | 863 | 0.3% | |
| 20741 | 863 | 0.3% | |
| 22777 | 863 | 0.3% | |
| 41773 | 863 | 0.3% | |
| 53033 | 863 | 0.3% | |
| 31768 | 863 | 0.3% | |
| 63309 | 863 | 0.3% | |
| 31112 | 863 | 0.3% | |
| Other values (3530) | 325645 | 96.5% |
| Value | Count | Frequency (%) | |
| 1 | 3061 | 0.9% | |
| 2 | 196 | 0.1% | |
| 3 | 119 | < 0.1% | |
| 4 | 144 | < 0.1% | |
| 5 | 162 | < 0.1% |
| Value | Count | Frequency (%) | |
| 153589 | 183 | 0.1% | |
| 148759 | 183 | 0.1% | |
| 140521 | 183 | 0.1% | |
| 132036 | 183 | 0.1% | |
| 126138 | 183 | 0.1% |
RECPI_MSA
Real number (ℝ≥0)
| Distinct count | 22837 |
|---|---|
| Unique (%) | 6.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.145562019091911 |
|---|---|
| Minimum | 2.37131e-05 |
| Maximum | 132.1134 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 2.37131e-05 |
|---|---|
| 5-th percentile | 0.017198302 |
| Q1 | 0.11930856 |
| median | 0.6555024 |
| Q3 | 5.2990756 |
| 95-th percentile | 23.799837 |
| Maximum | 132.1134 |
| Range | 132.1133763 |
| Interquartile range (IQR) | 5.17976704 |
Descriptive statistics
| Standard deviation | 10.29445346 |
|---|---|
| Coefficient of variation (CV) | 2.000647046 |
| Kurtosis | 30.989684 |
| Mean | 5.145562019 |
| Median Absolute Deviation (MAD) | 0.625868068 |
| Skewness | 4.330708467 |
| Sum | 1735783.309 |
| Variance | 105.9757719 |
| Value | Count | Frequency (%) | |
| 15.110121 | 863 | 0.3% | |
| 13.04385 | 863 | 0.3% | |
| 13.122136 | 863 | 0.3% | |
| 13.686826 | 863 | 0.3% | |
| 13.685439 | 863 | 0.3% | |
| 14.254283 | 863 | 0.3% | |
| 13.604632 | 863 | 0.3% | |
| 16.727505 | 863 | 0.3% | |
| 10.166127 | 863 | 0.3% | |
| 12.650854 | 863 | 0.3% | |
| Other values (22827) | 328706 | 97.4% |
| Value | Count | Frequency (%) | |
| 2.37131e-05 | 2 | < 0.1% | |
| 2.9056831e-05 | 6 | < 0.1% | |
| 3.2550477e-05 | 1 | < 0.1% | |
| 4.0748477e-05 | 6 | < 0.1% | |
| 4.1634128e-05 | 22 | < 0.1% |
| Value | Count | Frequency (%) | |
| 132.1134 | 145 | < 0.1% | |
| 117.37917 | 145 | < 0.1% | |
| 114.993835 | 145 | < 0.1% | |
| 98.44064 | 145 | < 0.1% | |
| 84.49912 | 145 | < 0.1% |
EQI_state
Real number (ℝ≥0)
| Distinct count | 1444 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0006086236619870218 |
|---|---|
| Minimum | 7.426358e-05 |
| Maximum | 0.0037453347 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 7.426358e-05 |
|---|---|
| 5-th percentile | 0.00016987788 |
| Q1 | 0.00030454743 |
| median | 0.0004428451 |
| Q3 | 0.0006381583 |
| 95-th percentile | 0.0018966781 |
| Maximum | 0.0037453347 |
| Range | 0.00367107112 |
| Interquartile range (IQR) | 0.00033361087 |
Descriptive statistics
| Standard deviation | 0.0005196898527 |
|---|---|
| Coefficient of variation (CV) | 0.8538771743 |
| Kurtosis | 5.144266833 |
| Mean | 0.000608623662 |
| Median Absolute Deviation (MAD) | 0.00015669737 |
| Skewness | 2.226484269 |
| Sum | 205.3106716 |
| Variance | 2.70077543e-07 |
| Value | Count | Frequency (%) | |
| 0.00042931232 | 918 | 0.3% | |
| 0.00030860028 | 918 | 0.3% | |
| 0.00031185208 | 918 | 0.3% | |
| 0.000318638 | 918 | 0.3% | |
| 0.00046185814 | 918 | 0.3% | |
| 0.000459364 | 918 | 0.3% | |
| 0.00045583185 | 918 | 0.3% | |
| 0.00043291016 | 918 | 0.3% | |
| 0.00030589235 | 918 | 0.3% | |
| 0.0004638483 | 918 | 0.3% | |
| Other values (1434) | 328156 | 97.3% |
| Value | Count | Frequency (%) | |
| 7.426358e-05 | 103 | < 0.1% | |
| 7.8000994e-05 | 103 | < 0.1% | |
| 7.82489e-05 | 103 | < 0.1% | |
| 8.127372e-05 | 103 | < 0.1% | |
| 8.188262e-05 | 11 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0.0037453347 | 408 | 0.1% | |
| 0.0030291597 | 408 | 0.1% | |
| 0.002947922 | 408 | 0.1% | |
| 0.0027841919 | 707 | 0.2% | |
| 0.002605618 | 707 | 0.2% |
SFR_state
Real number (ℝ≥0)
| Distinct count | 1427 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 53603.12074904546 |
|---|---|
| Minimum | 40.0 |
| Maximum | 330536.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 40 |
|---|---|
| 5-th percentile | 4881 |
| Q1 | 16805 |
| median | 35247 |
| Q3 | 68137 |
| 95-th percentile | 168977 |
| Maximum | 330536 |
| Range | 330496 |
| Interquartile range (IQR) | 51332 |
Descriptive statistics
| Standard deviation | 56886.5504 |
|---|---|
| Coefficient of variation (CV) | 1.061254449 |
| Kurtosis | 5.398992322 |
| Mean | 53603.12075 |
| Median Absolute Deviation (MAD) | 22169 |
| Skewness | 2.177968699 |
| Sum | 1.808226234e+10 |
| Variance | 3236079616 |
| Value | Count | Frequency (%) | |
| 113623 | 1649 | 0.5% | |
| 18675 | 1085 | 0.3% | |
| 83609 | 918 | 0.3% | |
| 80986 | 918 | 0.3% | |
| 111615 | 918 | 0.3% | |
| 57966 | 918 | 0.3% | |
| 135807 | 918 | 0.3% | |
| 84556 | 918 | 0.3% | |
| 60289 | 918 | 0.3% | |
| 134403 | 918 | 0.3% | |
| Other values (1417) | 327258 | 97.0% |
| Value | Count | Frequency (%) | |
| 40 | 1 | < 0.1% | |
| 63 | 1 | < 0.1% | |
| 65 | 1 | < 0.1% | |
| 71 | 1 | < 0.1% | |
| 94 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 330536 | 800 | 0.2% | |
| 313960 | 800 | 0.2% | |
| 295716 | 800 | 0.2% | |
| 287591 | 800 | 0.2% | |
| 276889 | 800 | 0.2% |
RECPI_state
Real number (ℝ≥0)
| Distinct count | 1444 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 34.09501161652317 |
|---|---|
| Minimum | 0.01783298 |
| Maximum | 442.21994000000007 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 0.01783298 |
|---|---|
| 5-th percentile | 1.5838081 |
| Q1 | 6.9673257 |
| median | 16.268452 |
| Q3 | 35.56701 |
| 95-th percentile | 93.418846 |
| Maximum | 442.21994 |
| Range | 442.202107 |
| Interquartile range (IQR) | 28.5996843 |
Descriptive statistics
| Standard deviation | 57.85914507 |
|---|---|
| Coefficient of variation (CV) | 1.696997371 |
| Kurtosis | 19.34143997 |
| Mean | 34.09501162 |
| Median Absolute Deviation (MAD) | 11.1700247 |
| Skewness | 4.109350654 |
| Sum | 11501474.84 |
| Variance | 3347.680669 |
| Value | Count | Frequency (%) | |
| 34.266712 | 918 | 0.3% | |
| 34.65051 | 918 | 0.3% | |
| 38.58028 | 918 | 0.3% | |
| 43.55995 | 918 | 0.3% | |
| 27.161385 | 918 | 0.3% | |
| 39.853615 | 918 | 0.3% | |
| 37.070427 | 918 | 0.3% | |
| 30.707523 | 918 | 0.3% | |
| 32.96178 | 918 | 0.3% | |
| 32.927654 | 918 | 0.3% | |
| Other values (1434) | 328156 | 97.3% |
| Value | Count | Frequency (%) | |
| 0.01783298 | 11 | < 0.1% | |
| 0.02767606 | 14 | < 0.1% | |
| 0.031676006 | 11 | < 0.1% | |
| 0.03247159 | 11 | < 0.1% | |
| 0.033504028 | 11 | < 0.1% |
| Value | Count | Frequency (%) | |
| 442.21994 | 707 | 0.2% | |
| 424.64432 | 707 | 0.2% | |
| 397.9958 | 707 | 0.2% | |
| 345.09607 | 707 | 0.2% | |
| 308.3075 | 707 | 0.2% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| year | zipcode | EQI_zip | SFR_zip | RECPI_zip | EQI_MSA | SFR_MSA | RECPI_MSA | EQI_state | SFR_state | RECPI_state | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1988 | 1001 | 0.000815 | 48.0 | 0.039108 | 0.001021 | 1235.0 | 1.260888 | 0.001476 | 17558.0 | 25.92194 |
| 1 | 1988 | 1002 | 0.001764 | 35.0 | 0.061751 | 0.001021 | 1235.0 | 1.260888 | 0.001476 | 17558.0 | 25.92194 |
| 2 | 1988 | 1005 | 0.000752 | 8.0 | 0.006015 | 0.000428 | 104.0 | 0.044531 | 0.001476 | 17558.0 | 25.92194 |
| 3 | 1988 | 1007 | 0.000776 | 18.0 | 0.013976 | 0.001021 | 1235.0 | 1.260888 | 0.001476 | 17558.0 | 25.92194 |
| 4 | 1988 | 1010 | 0.000924 | 7.0 | 0.006471 | 0.001021 | 1235.0 | 1.260888 | 0.001476 | 17558.0 | 25.92194 |
| 5 | 1988 | 1013 | 0.000849 | 22.0 | 0.018671 | 0.001021 | 1235.0 | 1.260888 | 0.001476 | 17558.0 | 25.92194 |
| 6 | 1988 | 1020 | 0.000805 | 46.0 | 0.037015 | 0.001021 | 1235.0 | 1.260888 | 0.001476 | 17558.0 | 25.92194 |
| 7 | 1988 | 1027 | 0.003389 | 10.0 | 0.033888 | 0.001021 | 1235.0 | 1.260888 | 0.001476 | 17558.0 | 25.92194 |
| 8 | 1988 | 1028 | 0.000957 | 30.0 | 0.028711 | 0.001021 | 1235.0 | 1.260888 | 0.001476 | 17558.0 | 25.92194 |
| 9 | 1988 | 1030 | 0.000868 | 35.0 | 0.030392 | 0.001021 | 1235.0 | 1.260888 | 0.001476 | 17558.0 | 25.92194 |
Last rows
| year | zipcode | EQI_zip | SFR_zip | RECPI_zip | EQI_MSA | SFR_MSA | RECPI_MSA | EQI_state | SFR_state | RECPI_state | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 337326 | 2016 | 99503 | 0.000080 | 624.0 | 0.049858 | 0.000083 | 1993.0 | 0.165981 | 0.000082 | 3847.0 | 0.315002 |
| 337327 | 2016 | 99507 | 0.000080 | 109.0 | 0.008732 | 0.000083 | 1993.0 | 0.165981 | 0.000082 | 3847.0 | 0.315002 |
| 337328 | 2016 | 99508 | 0.000086 | 85.0 | 0.007283 | 0.000083 | 1993.0 | 0.165981 | 0.000082 | 3847.0 | 0.315002 |
| 337329 | 2016 | 99515 | 0.000081 | 102.0 | 0.008313 | 0.000083 | 1993.0 | 0.165981 | 0.000082 | 3847.0 | 0.315002 |
| 337330 | 2016 | 99518 | 0.000133 | 63.0 | 0.008356 | 0.000083 | 1993.0 | 0.165981 | 0.000082 | 3847.0 | 0.315002 |
| 337331 | 2016 | 99577 | 0.000083 | 88.0 | 0.007272 | 0.000083 | 1993.0 | 0.165981 | 0.000082 | 3847.0 | 0.315002 |
| 337332 | 2016 | 99701 | 0.000088 | 62.0 | 0.005454 | 0.000078 | 280.0 | 0.021749 | 0.000082 | 3847.0 | 0.315002 |
| 337333 | 2016 | 99709 | 0.000075 | 73.0 | 0.005441 | 0.000078 | 280.0 | 0.021749 | 0.000082 | 3847.0 | 0.315002 |
| 337334 | 2016 | 99801 | 0.000064 | 70.0 | 0.004492 | 0.000066 | 78.0 | 0.005128 | 0.000082 | 3847.0 | 0.315002 |
| 337335 | 2016 | 99901 | 0.000076 | 47.0 | 0.003571 | 0.000073 | 54.0 | 0.003929 | 0.000082 | 3847.0 | 0.315002 |